<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: Lenovo
  Date: 2018/5/26
  Time: 21:16
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>添加用户</title>
    <meta http-equiv="refresh" content="1;URL=http://localhost:8080/index.jsp">
    <meta http-equiv="Content-Type" content="text/css" charset="UTF-8">
</head>
<body>
   <%
       request.setCharacterEncoding("utf-8");
       String username=request.getParameter("username");
       String password=request.getParameter("password");


//3+1
       Connection connection=null;
       Statement statement=null;

       //插入数据
       String sql="insert into t_users(username,password)  value('"+username+"','"+password+"')";
       Class.forName("com.mysql.jdbc.Driver");

       connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/sctu_javaweb_2018",
               "root",
               "413618"
       );

       statement=connection.createStatement();
       Boolean resultSet = statement.execute(sql);

       statement.close();
       connection.close();

   %>

</body>
</html>
